Hi, every day i will get a XML zip file in ftp.while i am executing that ftp it has to take the current date zip XML file. i think for that i need to write c# code i am new to c# code can any one help me out

Not really sure what you're looking for but... Does the filename of the files on the ftp server have a date in it? And do you want the file that has the date from today in it's name? If so you can probably get the same result with expressions, but here is some code for ftp: http://ssisctc.codeplex.com/wikipage?title=Script%20Task%3a%20FTP&referringTitle=Home Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com

I think what the OP is trying to say is that everyday a zipped XML file is placed on a FTP server and he needs to only pull down that days file i.e. Today is 30/05/2011. There could be zip files on the server from 29/05/2011, 28/05/2011 etc. He needs to only download the the zip file dated 30/05/2011. What the OP needs to let us know is whether the file names reflect the date i.e. xml_30052011.zip etcJeff Wharton MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt) MCT, MCPD, MCITP, MCDBA Blog: Mr. Wharty's Ramblings Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker

Hi, You can do that directly using the task available, if you want to do some customization then u can use the script task and do some C# code to do that.Thanks Karthikeyan Anbarasan www.F5Debug.net

Hi, You can do that directly using the task available, if you want to do some customization then u can use the script task and do some C# code to do that.Thanks Karthikeyan Anbarasan www.F5Debug.net

Hi, You can do that directly using the task available, if you want to do some customization then u can use the script task and do some C# code to do that. Thanks Karthikeyan Anbarasan www.F5Debug.net As far as I'm aware, there are no properties on the FTP Task that tell it to get the newest file out of a list of files.Jeff Wharton MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt) MCT, MCPD, MCITP, MCDBA Blog: Mr. Wharty's Ramblings Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker

Hi, You can do that directly using the task available, if you want to do some customization then u can use the script task and do some C# code to do that. Thanks Karthikeyan Anbarasan www.F5Debug.net As far as I'm aware, there are no properties on the FTP Task that tell it to get the newest file out of a list of files.Jeff Wharton MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt) MCT, MCPD, MCITP, MCDBA Blog: Mr. Wharty's Ramblings Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker

yes accepted, we need to write out customized code(may be we can use the script task) to make a validation to fetch the latest file.Thanks Karthikeyan Anbarasan http://f5debug.net/

yes accepted, we need to write out customized code(may be we can use the script task) to make a validation to fetch the latest file.Thanks Karthikeyan Anbarasan http://f5debug.net/

Are you using the actual filedate or can you find the filedate in the filename? - If the date is in the filename you can set the RemotePath (or RemoteVariable) property with an expression. - If you want the actual file date you need a Script Task. Here is sample code for parsing FtpwebRequest response for ListDirectoryDetails (such as creationdate): http://blogs.msdn.com/b/adarshk/archive/2004/09/15/230177.aspxPlease mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com